	<div id="Content">

		<div id="One">
			<H2>&raquo; Admin</H2>

            <div id="contenitore">

                <div id="table">

              <p>Lista dei tickets:</p>
              <div id="cerca" align="right">
	<input id="cerca" type="text" value="cerca ticket" maxlength="20" size="42" name="cerca"/>
	<button type="submit">Cerca</button>
    </div>
    <br /><br />

     <?php


     if(isset($_GET['show']) && $_GET['show'] == 'miei_ticket'){
         // qui fai la query
         $query="SELECT * FROM ticket where assegnato_a = " . $utente->id;
     }

     $username="root";
     $password="";
     $database="ticket";

     mysql_connect(localhost,$username,$password);
     @mysql_select_db($database) or die("Impossibile selezionare il database");
     $query="SELECT * FROM ticket";
     $risultati=mysql_query($query);

     $num=mysql_numrows($risultati);

     mysql_close();
     ?>
              <blockquote>
              <table>
                  <tr>
                <th>Cognome</th>
                <th>Nome</th>
                <th>Eta</th>
                <th>Aula</th>
                <th>E-mail</th>
                <th>Testo</th>
                <th>Data</th>
                  </tr>

                <?php
                     $i=0;
                     while ($i < $num) {
                         $nome=mysql_result($risultati,$i,"nome");
                         $cognome=mysql_result($risultati,$i,"cognome");
                         $eta=mysql_result($risultati,$i,"eta");
                 ?>

                  <tr>
                     <td><?php echo $nome;?></td>
                     <td><?php echo $cognome;?></td>
                     <td><?php echo $eta;?></td>
                     <td></td>
                     <td></td>
                     <td></td>
                     <td></td>
                  </tr>
                 <?php
                 $i++;
                 }
                 ?>

                </table>
                </blockquote>
              </div>


                <br /><br />

                <div align="right"><a href="admin.html"><button type="botton">Chiudi</button></a></div>

                </form>
                </blockquote>
                </div>
	  </div>

	</div>

</div>